Filter limitations

When creating a filter, the following limitations apply:

• Filters are not supported for calculating columns of Right-to-Left languages.
• Filters can only be applied to immutable columns.

• Filters on mutable columns:

  When a filter is created to exclude/include specific rows in a column, the specified rows will always be excluded/included, even if the rows that were originally excluded/included are later changed. For example, if you chose to exclude/include rows "1-10" in a column named "Age" and those rows were later changed to "11-20", the rows will continue to be excluded/included, even though the data is no longer the same.

  Additionally, if a row outside the filter scope was changed (i.e. updated or updated and then deleted) so that it should now be excluded/included (as defined by the filter), it will not be replicated to the target. So, for example if you created a filter to exclude/include rows less than 5 and then changed row 6 to -6, it will not be replicated (even though it is included in the filter's criteria range).

• Filter cannot be applied to LOB columns.

• When specifying numeric data as a filtering condition, the data preceding the decimal point cannot exceed int64.